package com.ssish.saas.eccs.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class MmtIclaimExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MmtIclaimExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIclaimidIsNull() {
            addCriterion("ICLAIMID is null");
            return (Criteria) this;
        }

        public Criteria andIclaimidIsNotNull() {
            addCriterion("ICLAIMID is not null");
            return (Criteria) this;
        }

        public Criteria andIclaimidEqualTo(String value) {
            addCriterion("ICLAIMID =", value, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andIclaimidNotEqualTo(String value) {
            addCriterion("ICLAIMID <>", value, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andIclaimidGreaterThan(String value) {
            addCriterion("ICLAIMID >", value, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andIclaimidGreaterThanOrEqualTo(String value) {
            addCriterion("ICLAIMID >=", value, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andIclaimidLessThan(String value) {
            addCriterion("ICLAIMID <", value, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andIclaimidLessThanOrEqualTo(String value) {
            addCriterion("ICLAIMID <=", value, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andIclaimidLike(String value) {
            addCriterion("ICLAIMID like", value, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andIclaimidNotLike(String value) {
            addCriterion("ICLAIMID not like", value, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andIclaimidIn(List<String> values) {
            addCriterion("ICLAIMID in", values, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andIclaimidNotIn(List<String> values) {
            addCriterion("ICLAIMID not in", values, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andIclaimidBetween(String value1, String value2) {
            addCriterion("ICLAIMID between", value1, value2, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andIclaimidNotBetween(String value1, String value2) {
            addCriterion("ICLAIMID not between", value1, value2, "iclaimid");
            return (Criteria) this;
        }

        public Criteria andInsbyIsNull() {
            addCriterion("INSBY is null");
            return (Criteria) this;
        }

        public Criteria andInsbyIsNotNull() {
            addCriterion("INSBY is not null");
            return (Criteria) this;
        }

        public Criteria andInsbyEqualTo(String value) {
            addCriterion("INSBY =", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyNotEqualTo(String value) {
            addCriterion("INSBY <>", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyGreaterThan(String value) {
            addCriterion("INSBY >", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyGreaterThanOrEqualTo(String value) {
            addCriterion("INSBY >=", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyLessThan(String value) {
            addCriterion("INSBY <", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyLessThanOrEqualTo(String value) {
            addCriterion("INSBY <=", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyLike(String value) {
            addCriterion("INSBY like", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyNotLike(String value) {
            addCriterion("INSBY not like", value, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyIn(List<String> values) {
            addCriterion("INSBY in", values, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyNotIn(List<String> values) {
            addCriterion("INSBY not in", values, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyBetween(String value1, String value2) {
            addCriterion("INSBY between", value1, value2, "insby");
            return (Criteria) this;
        }

        public Criteria andInsbyNotBetween(String value1, String value2) {
            addCriterion("INSBY not between", value1, value2, "insby");
            return (Criteria) this;
        }

        public Criteria andInsdtIsNull() {
            addCriterion("INSDT is null");
            return (Criteria) this;
        }

        public Criteria andInsdtIsNotNull() {
            addCriterion("INSDT is not null");
            return (Criteria) this;
        }

        public Criteria andInsdtEqualTo(Date value) {
            addCriterion("INSDT =", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtNotEqualTo(Date value) {
            addCriterion("INSDT <>", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtGreaterThan(Date value) {
            addCriterion("INSDT >", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtGreaterThanOrEqualTo(Date value) {
            addCriterion("INSDT >=", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtLessThan(Date value) {
            addCriterion("INSDT <", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtLessThanOrEqualTo(Date value) {
            addCriterion("INSDT <=", value, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtIn(List<Date> values) {
            addCriterion("INSDT in", values, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtNotIn(List<Date> values) {
            addCriterion("INSDT not in", values, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtBetween(Date value1, Date value2) {
            addCriterion("INSDT between", value1, value2, "insdt");
            return (Criteria) this;
        }

        public Criteria andInsdtNotBetween(Date value1, Date value2) {
            addCriterion("INSDT not between", value1, value2, "insdt");
            return (Criteria) this;
        }

        public Criteria andUpdbyIsNull() {
            addCriterion("UPDBY is null");
            return (Criteria) this;
        }

        public Criteria andUpdbyIsNotNull() {
            addCriterion("UPDBY is not null");
            return (Criteria) this;
        }

        public Criteria andUpdbyEqualTo(String value) {
            addCriterion("UPDBY =", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyNotEqualTo(String value) {
            addCriterion("UPDBY <>", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyGreaterThan(String value) {
            addCriterion("UPDBY >", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyGreaterThanOrEqualTo(String value) {
            addCriterion("UPDBY >=", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyLessThan(String value) {
            addCriterion("UPDBY <", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyLessThanOrEqualTo(String value) {
            addCriterion("UPDBY <=", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyLike(String value) {
            addCriterion("UPDBY like", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyNotLike(String value) {
            addCriterion("UPDBY not like", value, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyIn(List<String> values) {
            addCriterion("UPDBY in", values, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyNotIn(List<String> values) {
            addCriterion("UPDBY not in", values, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyBetween(String value1, String value2) {
            addCriterion("UPDBY between", value1, value2, "updby");
            return (Criteria) this;
        }

        public Criteria andUpdbyNotBetween(String value1, String value2) {
            addCriterion("UPDBY not between", value1, value2, "updby");
            return (Criteria) this;
        }

        public Criteria andUpddtIsNull() {
            addCriterion("UPDDT is null");
            return (Criteria) this;
        }

        public Criteria andUpddtIsNotNull() {
            addCriterion("UPDDT is not null");
            return (Criteria) this;
        }

        public Criteria andUpddtEqualTo(Date value) {
            addCriterion("UPDDT =", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtNotEqualTo(Date value) {
            addCriterion("UPDDT <>", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtGreaterThan(Date value) {
            addCriterion("UPDDT >", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDDT >=", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtLessThan(Date value) {
            addCriterion("UPDDT <", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtLessThanOrEqualTo(Date value) {
            addCriterion("UPDDT <=", value, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtIn(List<Date> values) {
            addCriterion("UPDDT in", values, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtNotIn(List<Date> values) {
            addCriterion("UPDDT not in", values, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtBetween(Date value1, Date value2) {
            addCriterion("UPDDT between", value1, value2, "upddt");
            return (Criteria) this;
        }

        public Criteria andUpddtNotBetween(Date value1, Date value2) {
            addCriterion("UPDDT not between", value1, value2, "upddt");
            return (Criteria) this;
        }

        public Criteria andIclaimstsIsNull() {
            addCriterion("ICLAIMSTS is null");
            return (Criteria) this;
        }

        public Criteria andIclaimstsIsNotNull() {
            addCriterion("ICLAIMSTS is not null");
            return (Criteria) this;
        }

        public Criteria andIclaimstsEqualTo(String value) {
            addCriterion("ICLAIMSTS =", value, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andIclaimstsNotEqualTo(String value) {
            addCriterion("ICLAIMSTS <>", value, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andIclaimstsGreaterThan(String value) {
            addCriterion("ICLAIMSTS >", value, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andIclaimstsGreaterThanOrEqualTo(String value) {
            addCriterion("ICLAIMSTS >=", value, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andIclaimstsLessThan(String value) {
            addCriterion("ICLAIMSTS <", value, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andIclaimstsLessThanOrEqualTo(String value) {
            addCriterion("ICLAIMSTS <=", value, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andIclaimstsLike(String value) {
            addCriterion("ICLAIMSTS like", value, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andIclaimstsNotLike(String value) {
            addCriterion("ICLAIMSTS not like", value, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andIclaimstsIn(List<String> values) {
            addCriterion("ICLAIMSTS in", values, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andIclaimstsNotIn(List<String> values) {
            addCriterion("ICLAIMSTS not in", values, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andIclaimstsBetween(String value1, String value2) {
            addCriterion("ICLAIMSTS between", value1, value2, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andIclaimstsNotBetween(String value1, String value2) {
            addCriterion("ICLAIMSTS not between", value1, value2, "iclaimsts");
            return (Criteria) this;
        }

        public Criteria andRegdtIsNull() {
            addCriterion("REGDT is null");
            return (Criteria) this;
        }

        public Criteria andRegdtIsNotNull() {
            addCriterion("REGDT is not null");
            return (Criteria) this;
        }

        public Criteria andRegdtEqualTo(Date value) {
            addCriterion("REGDT =", value, "regdt");
            return (Criteria) this;
        }

        public Criteria andRegdtNotEqualTo(Date value) {
            addCriterion("REGDT <>", value, "regdt");
            return (Criteria) this;
        }

        public Criteria andRegdtGreaterThan(Date value) {
            addCriterion("REGDT >", value, "regdt");
            return (Criteria) this;
        }

        public Criteria andRegdtGreaterThanOrEqualTo(Date value) {
            addCriterion("REGDT >=", value, "regdt");
            return (Criteria) this;
        }

        public Criteria andRegdtLessThan(Date value) {
            addCriterion("REGDT <", value, "regdt");
            return (Criteria) this;
        }

        public Criteria andRegdtLessThanOrEqualTo(Date value) {
            addCriterion("REGDT <=", value, "regdt");
            return (Criteria) this;
        }

        public Criteria andRegdtIn(List<Date> values) {
            addCriterion("REGDT in", values, "regdt");
            return (Criteria) this;
        }

        public Criteria andRegdtNotIn(List<Date> values) {
            addCriterion("REGDT not in", values, "regdt");
            return (Criteria) this;
        }

        public Criteria andRegdtBetween(Date value1, Date value2) {
            addCriterion("REGDT between", value1, value2, "regdt");
            return (Criteria) this;
        }

        public Criteria andRegdtNotBetween(Date value1, Date value2) {
            addCriterion("REGDT not between", value1, value2, "regdt");
            return (Criteria) this;
        }

        public Criteria andInvnoIsNull() {
            addCriterion("INVNO is null");
            return (Criteria) this;
        }

        public Criteria andInvnoIsNotNull() {
            addCriterion("INVNO is not null");
            return (Criteria) this;
        }

        public Criteria andInvnoEqualTo(String value) {
            addCriterion("INVNO =", value, "invno");
            return (Criteria) this;
        }

        public Criteria andInvnoNotEqualTo(String value) {
            addCriterion("INVNO <>", value, "invno");
            return (Criteria) this;
        }

        public Criteria andInvnoGreaterThan(String value) {
            addCriterion("INVNO >", value, "invno");
            return (Criteria) this;
        }

        public Criteria andInvnoGreaterThanOrEqualTo(String value) {
            addCriterion("INVNO >=", value, "invno");
            return (Criteria) this;
        }

        public Criteria andInvnoLessThan(String value) {
            addCriterion("INVNO <", value, "invno");
            return (Criteria) this;
        }

        public Criteria andInvnoLessThanOrEqualTo(String value) {
            addCriterion("INVNO <=", value, "invno");
            return (Criteria) this;
        }

        public Criteria andInvnoLike(String value) {
            addCriterion("INVNO like", value, "invno");
            return (Criteria) this;
        }

        public Criteria andInvnoNotLike(String value) {
            addCriterion("INVNO not like", value, "invno");
            return (Criteria) this;
        }

        public Criteria andInvnoIn(List<String> values) {
            addCriterion("INVNO in", values, "invno");
            return (Criteria) this;
        }

        public Criteria andInvnoNotIn(List<String> values) {
            addCriterion("INVNO not in", values, "invno");
            return (Criteria) this;
        }

        public Criteria andInvnoBetween(String value1, String value2) {
            addCriterion("INVNO between", value1, value2, "invno");
            return (Criteria) this;
        }

        public Criteria andInvnoNotBetween(String value1, String value2) {
            addCriterion("INVNO not between", value1, value2, "invno");
            return (Criteria) this;
        }

        public Criteria andInvamtIsNull() {
            addCriterion("INVAMT is null");
            return (Criteria) this;
        }

        public Criteria andInvamtIsNotNull() {
            addCriterion("INVAMT is not null");
            return (Criteria) this;
        }

        public Criteria andInvamtEqualTo(BigDecimal value) {
            addCriterion("INVAMT =", value, "invamt");
            return (Criteria) this;
        }

        public Criteria andInvamtNotEqualTo(BigDecimal value) {
            addCriterion("INVAMT <>", value, "invamt");
            return (Criteria) this;
        }

        public Criteria andInvamtGreaterThan(BigDecimal value) {
            addCriterion("INVAMT >", value, "invamt");
            return (Criteria) this;
        }

        public Criteria andInvamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("INVAMT >=", value, "invamt");
            return (Criteria) this;
        }

        public Criteria andInvamtLessThan(BigDecimal value) {
            addCriterion("INVAMT <", value, "invamt");
            return (Criteria) this;
        }

        public Criteria andInvamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("INVAMT <=", value, "invamt");
            return (Criteria) this;
        }

        public Criteria andInvamtIn(List<BigDecimal> values) {
            addCriterion("INVAMT in", values, "invamt");
            return (Criteria) this;
        }

        public Criteria andInvamtNotIn(List<BigDecimal> values) {
            addCriterion("INVAMT not in", values, "invamt");
            return (Criteria) this;
        }

        public Criteria andInvamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("INVAMT between", value1, value2, "invamt");
            return (Criteria) this;
        }

        public Criteria andInvamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("INVAMT not between", value1, value2, "invamt");
            return (Criteria) this;
        }

        public Criteria andMemidIsNull() {
            addCriterion("MEMID is null");
            return (Criteria) this;
        }

        public Criteria andMemidIsNotNull() {
            addCriterion("MEMID is not null");
            return (Criteria) this;
        }

        public Criteria andMemidEqualTo(String value) {
            addCriterion("MEMID =", value, "memid");
            return (Criteria) this;
        }

        public Criteria andMemidNotEqualTo(String value) {
            addCriterion("MEMID <>", value, "memid");
            return (Criteria) this;
        }

        public Criteria andMemidGreaterThan(String value) {
            addCriterion("MEMID >", value, "memid");
            return (Criteria) this;
        }

        public Criteria andMemidGreaterThanOrEqualTo(String value) {
            addCriterion("MEMID >=", value, "memid");
            return (Criteria) this;
        }

        public Criteria andMemidLessThan(String value) {
            addCriterion("MEMID <", value, "memid");
            return (Criteria) this;
        }

        public Criteria andMemidLessThanOrEqualTo(String value) {
            addCriterion("MEMID <=", value, "memid");
            return (Criteria) this;
        }

        public Criteria andMemidLike(String value) {
            addCriterion("MEMID like", value, "memid");
            return (Criteria) this;
        }

        public Criteria andMemidNotLike(String value) {
            addCriterion("MEMID not like", value, "memid");
            return (Criteria) this;
        }

        public Criteria andMemidIn(List<String> values) {
            addCriterion("MEMID in", values, "memid");
            return (Criteria) this;
        }

        public Criteria andMemidNotIn(List<String> values) {
            addCriterion("MEMID not in", values, "memid");
            return (Criteria) this;
        }

        public Criteria andMemidBetween(String value1, String value2) {
            addCriterion("MEMID between", value1, value2, "memid");
            return (Criteria) this;
        }

        public Criteria andMemidNotBetween(String value1, String value2) {
            addCriterion("MEMID not between", value1, value2, "memid");
            return (Criteria) this;
        }

        public Criteria andPatientnmIsNull() {
            addCriterion("PATIENTNM is null");
            return (Criteria) this;
        }

        public Criteria andPatientnmIsNotNull() {
            addCriterion("PATIENTNM is not null");
            return (Criteria) this;
        }

        public Criteria andPatientnmEqualTo(String value) {
            addCriterion("PATIENTNM =", value, "patientnm");
            return (Criteria) this;
        }

        public Criteria andPatientnmNotEqualTo(String value) {
            addCriterion("PATIENTNM <>", value, "patientnm");
            return (Criteria) this;
        }

        public Criteria andPatientnmGreaterThan(String value) {
            addCriterion("PATIENTNM >", value, "patientnm");
            return (Criteria) this;
        }

        public Criteria andPatientnmGreaterThanOrEqualTo(String value) {
            addCriterion("PATIENTNM >=", value, "patientnm");
            return (Criteria) this;
        }

        public Criteria andPatientnmLessThan(String value) {
            addCriterion("PATIENTNM <", value, "patientnm");
            return (Criteria) this;
        }

        public Criteria andPatientnmLessThanOrEqualTo(String value) {
            addCriterion("PATIENTNM <=", value, "patientnm");
            return (Criteria) this;
        }

        public Criteria andPatientnmLike(String value) {
            addCriterion("PATIENTNM like", value, "patientnm");
            return (Criteria) this;
        }

        public Criteria andPatientnmNotLike(String value) {
            addCriterion("PATIENTNM not like", value, "patientnm");
            return (Criteria) this;
        }

        public Criteria andPatientnmIn(List<String> values) {
            addCriterion("PATIENTNM in", values, "patientnm");
            return (Criteria) this;
        }

        public Criteria andPatientnmNotIn(List<String> values) {
            addCriterion("PATIENTNM not in", values, "patientnm");
            return (Criteria) this;
        }

        public Criteria andPatientnmBetween(String value1, String value2) {
            addCriterion("PATIENTNM between", value1, value2, "patientnm");
            return (Criteria) this;
        }

        public Criteria andPatientnmNotBetween(String value1, String value2) {
            addCriterion("PATIENTNM not between", value1, value2, "patientnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmIsNull() {
            addCriterion("EMPNM is null");
            return (Criteria) this;
        }

        public Criteria andEmpnmIsNotNull() {
            addCriterion("EMPNM is not null");
            return (Criteria) this;
        }

        public Criteria andEmpnmEqualTo(String value) {
            addCriterion("EMPNM =", value, "empnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmNotEqualTo(String value) {
            addCriterion("EMPNM <>", value, "empnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmGreaterThan(String value) {
            addCriterion("EMPNM >", value, "empnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmGreaterThanOrEqualTo(String value) {
            addCriterion("EMPNM >=", value, "empnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmLessThan(String value) {
            addCriterion("EMPNM <", value, "empnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmLessThanOrEqualTo(String value) {
            addCriterion("EMPNM <=", value, "empnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmLike(String value) {
            addCriterion("EMPNM like", value, "empnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmNotLike(String value) {
            addCriterion("EMPNM not like", value, "empnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmIn(List<String> values) {
            addCriterion("EMPNM in", values, "empnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmNotIn(List<String> values) {
            addCriterion("EMPNM not in", values, "empnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmBetween(String value1, String value2) {
            addCriterion("EMPNM between", value1, value2, "empnm");
            return (Criteria) this;
        }

        public Criteria andEmpnmNotBetween(String value1, String value2) {
            addCriterion("EMPNM not between", value1, value2, "empnm");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNull() {
            addCriterion("CARDNO is null");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNotNull() {
            addCriterion("CARDNO is not null");
            return (Criteria) this;
        }

        public Criteria andCardnoEqualTo(BigDecimal value) {
            addCriterion("CARDNO =", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotEqualTo(BigDecimal value) {
            addCriterion("CARDNO <>", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThan(BigDecimal value) {
            addCriterion("CARDNO >", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CARDNO >=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThan(BigDecimal value) {
            addCriterion("CARDNO <", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CARDNO <=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoIn(List<BigDecimal> values) {
            addCriterion("CARDNO in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotIn(List<BigDecimal> values) {
            addCriterion("CARDNO not in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARDNO between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARDNO not between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andEmpidIsNull() {
            addCriterion("EMPID is null");
            return (Criteria) this;
        }

        public Criteria andEmpidIsNotNull() {
            addCriterion("EMPID is not null");
            return (Criteria) this;
        }

        public Criteria andEmpidEqualTo(String value) {
            addCriterion("EMPID =", value, "empid");
            return (Criteria) this;
        }

        public Criteria andEmpidNotEqualTo(String value) {
            addCriterion("EMPID <>", value, "empid");
            return (Criteria) this;
        }

        public Criteria andEmpidGreaterThan(String value) {
            addCriterion("EMPID >", value, "empid");
            return (Criteria) this;
        }

        public Criteria andEmpidGreaterThanOrEqualTo(String value) {
            addCriterion("EMPID >=", value, "empid");
            return (Criteria) this;
        }

        public Criteria andEmpidLessThan(String value) {
            addCriterion("EMPID <", value, "empid");
            return (Criteria) this;
        }

        public Criteria andEmpidLessThanOrEqualTo(String value) {
            addCriterion("EMPID <=", value, "empid");
            return (Criteria) this;
        }

        public Criteria andEmpidLike(String value) {
            addCriterion("EMPID like", value, "empid");
            return (Criteria) this;
        }

        public Criteria andEmpidNotLike(String value) {
            addCriterion("EMPID not like", value, "empid");
            return (Criteria) this;
        }

        public Criteria andEmpidIn(List<String> values) {
            addCriterion("EMPID in", values, "empid");
            return (Criteria) this;
        }

        public Criteria andEmpidNotIn(List<String> values) {
            addCriterion("EMPID not in", values, "empid");
            return (Criteria) this;
        }

        public Criteria andEmpidBetween(String value1, String value2) {
            addCriterion("EMPID between", value1, value2, "empid");
            return (Criteria) this;
        }

        public Criteria andEmpidNotBetween(String value1, String value2) {
            addCriterion("EMPID not between", value1, value2, "empid");
            return (Criteria) this;
        }

        public Criteria andDepidIsNull() {
            addCriterion("DEPID is null");
            return (Criteria) this;
        }

        public Criteria andDepidIsNotNull() {
            addCriterion("DEPID is not null");
            return (Criteria) this;
        }

        public Criteria andDepidEqualTo(String value) {
            addCriterion("DEPID =", value, "depid");
            return (Criteria) this;
        }

        public Criteria andDepidNotEqualTo(String value) {
            addCriterion("DEPID <>", value, "depid");
            return (Criteria) this;
        }

        public Criteria andDepidGreaterThan(String value) {
            addCriterion("DEPID >", value, "depid");
            return (Criteria) this;
        }

        public Criteria andDepidGreaterThanOrEqualTo(String value) {
            addCriterion("DEPID >=", value, "depid");
            return (Criteria) this;
        }

        public Criteria andDepidLessThan(String value) {
            addCriterion("DEPID <", value, "depid");
            return (Criteria) this;
        }

        public Criteria andDepidLessThanOrEqualTo(String value) {
            addCriterion("DEPID <=", value, "depid");
            return (Criteria) this;
        }

        public Criteria andDepidLike(String value) {
            addCriterion("DEPID like", value, "depid");
            return (Criteria) this;
        }

        public Criteria andDepidNotLike(String value) {
            addCriterion("DEPID not like", value, "depid");
            return (Criteria) this;
        }

        public Criteria andDepidIn(List<String> values) {
            addCriterion("DEPID in", values, "depid");
            return (Criteria) this;
        }

        public Criteria andDepidNotIn(List<String> values) {
            addCriterion("DEPID not in", values, "depid");
            return (Criteria) this;
        }

        public Criteria andDepidBetween(String value1, String value2) {
            addCriterion("DEPID between", value1, value2, "depid");
            return (Criteria) this;
        }

        public Criteria andDepidNotBetween(String value1, String value2) {
            addCriterion("DEPID not between", value1, value2, "depid");
            return (Criteria) this;
        }

        public Criteria andPayorcdIsNull() {
            addCriterion("PAYORCD is null");
            return (Criteria) this;
        }

        public Criteria andPayorcdIsNotNull() {
            addCriterion("PAYORCD is not null");
            return (Criteria) this;
        }

        public Criteria andPayorcdEqualTo(String value) {
            addCriterion("PAYORCD =", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdNotEqualTo(String value) {
            addCriterion("PAYORCD <>", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdGreaterThan(String value) {
            addCriterion("PAYORCD >", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdGreaterThanOrEqualTo(String value) {
            addCriterion("PAYORCD >=", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdLessThan(String value) {
            addCriterion("PAYORCD <", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdLessThanOrEqualTo(String value) {
            addCriterion("PAYORCD <=", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdLike(String value) {
            addCriterion("PAYORCD like", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdNotLike(String value) {
            addCriterion("PAYORCD not like", value, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdIn(List<String> values) {
            addCriterion("PAYORCD in", values, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdNotIn(List<String> values) {
            addCriterion("PAYORCD not in", values, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdBetween(String value1, String value2) {
            addCriterion("PAYORCD between", value1, value2, "payorcd");
            return (Criteria) this;
        }

        public Criteria andPayorcdNotBetween(String value1, String value2) {
            addCriterion("PAYORCD not between", value1, value2, "payorcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdIsNull() {
            addCriterion("CORPCD is null");
            return (Criteria) this;
        }

        public Criteria andCorpcdIsNotNull() {
            addCriterion("CORPCD is not null");
            return (Criteria) this;
        }

        public Criteria andCorpcdEqualTo(String value) {
            addCriterion("CORPCD =", value, "corpcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdNotEqualTo(String value) {
            addCriterion("CORPCD <>", value, "corpcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdGreaterThan(String value) {
            addCriterion("CORPCD >", value, "corpcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdGreaterThanOrEqualTo(String value) {
            addCriterion("CORPCD >=", value, "corpcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdLessThan(String value) {
            addCriterion("CORPCD <", value, "corpcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdLessThanOrEqualTo(String value) {
            addCriterion("CORPCD <=", value, "corpcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdLike(String value) {
            addCriterion("CORPCD like", value, "corpcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdNotLike(String value) {
            addCriterion("CORPCD not like", value, "corpcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdIn(List<String> values) {
            addCriterion("CORPCD in", values, "corpcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdNotIn(List<String> values) {
            addCriterion("CORPCD not in", values, "corpcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdBetween(String value1, String value2) {
            addCriterion("CORPCD between", value1, value2, "corpcd");
            return (Criteria) this;
        }

        public Criteria andCorpcdNotBetween(String value1, String value2) {
            addCriterion("CORPCD not between", value1, value2, "corpcd");
            return (Criteria) this;
        }

        public Criteria andIcnoIsNull() {
            addCriterion("ICNO is null");
            return (Criteria) this;
        }

        public Criteria andIcnoIsNotNull() {
            addCriterion("ICNO is not null");
            return (Criteria) this;
        }

        public Criteria andIcnoEqualTo(String value) {
            addCriterion("ICNO =", value, "icno");
            return (Criteria) this;
        }

        public Criteria andIcnoNotEqualTo(String value) {
            addCriterion("ICNO <>", value, "icno");
            return (Criteria) this;
        }

        public Criteria andIcnoGreaterThan(String value) {
            addCriterion("ICNO >", value, "icno");
            return (Criteria) this;
        }

        public Criteria andIcnoGreaterThanOrEqualTo(String value) {
            addCriterion("ICNO >=", value, "icno");
            return (Criteria) this;
        }

        public Criteria andIcnoLessThan(String value) {
            addCriterion("ICNO <", value, "icno");
            return (Criteria) this;
        }

        public Criteria andIcnoLessThanOrEqualTo(String value) {
            addCriterion("ICNO <=", value, "icno");
            return (Criteria) this;
        }

        public Criteria andIcnoLike(String value) {
            addCriterion("ICNO like", value, "icno");
            return (Criteria) this;
        }

        public Criteria andIcnoNotLike(String value) {
            addCriterion("ICNO not like", value, "icno");
            return (Criteria) this;
        }

        public Criteria andIcnoIn(List<String> values) {
            addCriterion("ICNO in", values, "icno");
            return (Criteria) this;
        }

        public Criteria andIcnoNotIn(List<String> values) {
            addCriterion("ICNO not in", values, "icno");
            return (Criteria) this;
        }

        public Criteria andIcnoBetween(String value1, String value2) {
            addCriterion("ICNO between", value1, value2, "icno");
            return (Criteria) this;
        }

        public Criteria andIcnoNotBetween(String value1, String value2) {
            addCriterion("ICNO not between", value1, value2, "icno");
            return (Criteria) this;
        }

        public Criteria andPolicynoIsNull() {
            addCriterion("POLICYNO is null");
            return (Criteria) this;
        }

        public Criteria andPolicynoIsNotNull() {
            addCriterion("POLICYNO is not null");
            return (Criteria) this;
        }

        public Criteria andPolicynoEqualTo(String value) {
            addCriterion("POLICYNO =", value, "policyno");
            return (Criteria) this;
        }

        public Criteria andPolicynoNotEqualTo(String value) {
            addCriterion("POLICYNO <>", value, "policyno");
            return (Criteria) this;
        }

        public Criteria andPolicynoGreaterThan(String value) {
            addCriterion("POLICYNO >", value, "policyno");
            return (Criteria) this;
        }

        public Criteria andPolicynoGreaterThanOrEqualTo(String value) {
            addCriterion("POLICYNO >=", value, "policyno");
            return (Criteria) this;
        }

        public Criteria andPolicynoLessThan(String value) {
            addCriterion("POLICYNO <", value, "policyno");
            return (Criteria) this;
        }

        public Criteria andPolicynoLessThanOrEqualTo(String value) {
            addCriterion("POLICYNO <=", value, "policyno");
            return (Criteria) this;
        }

        public Criteria andPolicynoLike(String value) {
            addCriterion("POLICYNO like", value, "policyno");
            return (Criteria) this;
        }

        public Criteria andPolicynoNotLike(String value) {
            addCriterion("POLICYNO not like", value, "policyno");
            return (Criteria) this;
        }

        public Criteria andPolicynoIn(List<String> values) {
            addCriterion("POLICYNO in", values, "policyno");
            return (Criteria) this;
        }

        public Criteria andPolicynoNotIn(List<String> values) {
            addCriterion("POLICYNO not in", values, "policyno");
            return (Criteria) this;
        }

        public Criteria andPolicynoBetween(String value1, String value2) {
            addCriterion("POLICYNO between", value1, value2, "policyno");
            return (Criteria) this;
        }

        public Criteria andPolicynoNotBetween(String value1, String value2) {
            addCriterion("POLICYNO not between", value1, value2, "policyno");
            return (Criteria) this;
        }

        public Criteria andRemIsNull() {
            addCriterion("REM is null");
            return (Criteria) this;
        }

        public Criteria andRemIsNotNull() {
            addCriterion("REM is not null");
            return (Criteria) this;
        }

        public Criteria andRemEqualTo(String value) {
            addCriterion("REM =", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemNotEqualTo(String value) {
            addCriterion("REM <>", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemGreaterThan(String value) {
            addCriterion("REM >", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemGreaterThanOrEqualTo(String value) {
            addCriterion("REM >=", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemLessThan(String value) {
            addCriterion("REM <", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemLessThanOrEqualTo(String value) {
            addCriterion("REM <=", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemLike(String value) {
            addCriterion("REM like", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemNotLike(String value) {
            addCriterion("REM not like", value, "rem");
            return (Criteria) this;
        }

        public Criteria andRemIn(List<String> values) {
            addCriterion("REM in", values, "rem");
            return (Criteria) this;
        }

        public Criteria andRemNotIn(List<String> values) {
            addCriterion("REM not in", values, "rem");
            return (Criteria) this;
        }

        public Criteria andRemBetween(String value1, String value2) {
            addCriterion("REM between", value1, value2, "rem");
            return (Criteria) this;
        }

        public Criteria andRemNotBetween(String value1, String value2) {
            addCriterion("REM not between", value1, value2, "rem");
            return (Criteria) this;
        }

        public Criteria andClaimsidIsNull() {
            addCriterion("CLAIMSID is null");
            return (Criteria) this;
        }

        public Criteria andClaimsidIsNotNull() {
            addCriterion("CLAIMSID is not null");
            return (Criteria) this;
        }

        public Criteria andClaimsidEqualTo(Integer value) {
            addCriterion("CLAIMSID =", value, "claimsid");
            return (Criteria) this;
        }

        public Criteria andClaimsidNotEqualTo(Integer value) {
            addCriterion("CLAIMSID <>", value, "claimsid");
            return (Criteria) this;
        }

        public Criteria andClaimsidGreaterThan(Integer value) {
            addCriterion("CLAIMSID >", value, "claimsid");
            return (Criteria) this;
        }

        public Criteria andClaimsidGreaterThanOrEqualTo(Integer value) {
            addCriterion("CLAIMSID >=", value, "claimsid");
            return (Criteria) this;
        }

        public Criteria andClaimsidLessThan(Integer value) {
            addCriterion("CLAIMSID <", value, "claimsid");
            return (Criteria) this;
        }

        public Criteria andClaimsidLessThanOrEqualTo(Integer value) {
            addCriterion("CLAIMSID <=", value, "claimsid");
            return (Criteria) this;
        }

        public Criteria andClaimsidIn(List<Integer> values) {
            addCriterion("CLAIMSID in", values, "claimsid");
            return (Criteria) this;
        }

        public Criteria andClaimsidNotIn(List<Integer> values) {
            addCriterion("CLAIMSID not in", values, "claimsid");
            return (Criteria) this;
        }

        public Criteria andClaimsidBetween(Integer value1, Integer value2) {
            addCriterion("CLAIMSID between", value1, value2, "claimsid");
            return (Criteria) this;
        }

        public Criteria andClaimsidNotBetween(Integer value1, Integer value2) {
            addCriterion("CLAIMSID not between", value1, value2, "claimsid");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtIsNull() {
            addCriterion("DOCRCVDT is null");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtIsNotNull() {
            addCriterion("DOCRCVDT is not null");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtEqualTo(Date value) {
            addCriterion("DOCRCVDT =", value, "docrcvdt");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtNotEqualTo(Date value) {
            addCriterion("DOCRCVDT <>", value, "docrcvdt");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtGreaterThan(Date value) {
            addCriterion("DOCRCVDT >", value, "docrcvdt");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtGreaterThanOrEqualTo(Date value) {
            addCriterion("DOCRCVDT >=", value, "docrcvdt");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtLessThan(Date value) {
            addCriterion("DOCRCVDT <", value, "docrcvdt");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtLessThanOrEqualTo(Date value) {
            addCriterion("DOCRCVDT <=", value, "docrcvdt");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtIn(List<Date> values) {
            addCriterion("DOCRCVDT in", values, "docrcvdt");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtNotIn(List<Date> values) {
            addCriterion("DOCRCVDT not in", values, "docrcvdt");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtBetween(Date value1, Date value2) {
            addCriterion("DOCRCVDT between", value1, value2, "docrcvdt");
            return (Criteria) this;
        }

        public Criteria andDocrcvdtNotBetween(Date value1, Date value2) {
            addCriterion("DOCRCVDT not between", value1, value2, "docrcvdt");
            return (Criteria) this;
        }

        public Criteria andVisitcntIsNull() {
            addCriterion("VISITCNT is null");
            return (Criteria) this;
        }

        public Criteria andVisitcntIsNotNull() {
            addCriterion("VISITCNT is not null");
            return (Criteria) this;
        }

        public Criteria andVisitcntEqualTo(Short value) {
            addCriterion("VISITCNT =", value, "visitcnt");
            return (Criteria) this;
        }

        public Criteria andVisitcntNotEqualTo(Short value) {
            addCriterion("VISITCNT <>", value, "visitcnt");
            return (Criteria) this;
        }

        public Criteria andVisitcntGreaterThan(Short value) {
            addCriterion("VISITCNT >", value, "visitcnt");
            return (Criteria) this;
        }

        public Criteria andVisitcntGreaterThanOrEqualTo(Short value) {
            addCriterion("VISITCNT >=", value, "visitcnt");
            return (Criteria) this;
        }

        public Criteria andVisitcntLessThan(Short value) {
            addCriterion("VISITCNT <", value, "visitcnt");
            return (Criteria) this;
        }

        public Criteria andVisitcntLessThanOrEqualTo(Short value) {
            addCriterion("VISITCNT <=", value, "visitcnt");
            return (Criteria) this;
        }

        public Criteria andVisitcntIn(List<Short> values) {
            addCriterion("VISITCNT in", values, "visitcnt");
            return (Criteria) this;
        }

        public Criteria andVisitcntNotIn(List<Short> values) {
            addCriterion("VISITCNT not in", values, "visitcnt");
            return (Criteria) this;
        }

        public Criteria andVisitcntBetween(Short value1, Short value2) {
            addCriterion("VISITCNT between", value1, value2, "visitcnt");
            return (Criteria) this;
        }

        public Criteria andVisitcntNotBetween(Short value1, Short value2) {
            addCriterion("VISITCNT not between", value1, value2, "visitcnt");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoIsNull() {
            addCriterion("PAYORREFNO is null");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoIsNotNull() {
            addCriterion("PAYORREFNO is not null");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoEqualTo(String value) {
            addCriterion("PAYORREFNO =", value, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoNotEqualTo(String value) {
            addCriterion("PAYORREFNO <>", value, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoGreaterThan(String value) {
            addCriterion("PAYORREFNO >", value, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoGreaterThanOrEqualTo(String value) {
            addCriterion("PAYORREFNO >=", value, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoLessThan(String value) {
            addCriterion("PAYORREFNO <", value, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoLessThanOrEqualTo(String value) {
            addCriterion("PAYORREFNO <=", value, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoLike(String value) {
            addCriterion("PAYORREFNO like", value, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoNotLike(String value) {
            addCriterion("PAYORREFNO not like", value, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoIn(List<String> values) {
            addCriterion("PAYORREFNO in", values, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoNotIn(List<String> values) {
            addCriterion("PAYORREFNO not in", values, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoBetween(String value1, String value2) {
            addCriterion("PAYORREFNO between", value1, value2, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andPayorrefnoNotBetween(String value1, String value2) {
            addCriterion("PAYORREFNO not between", value1, value2, "payorrefno");
            return (Criteria) this;
        }

        public Criteria andSubmitbyIsNull() {
            addCriterion("SUBMITBY is null");
            return (Criteria) this;
        }

        public Criteria andSubmitbyIsNotNull() {
            addCriterion("SUBMITBY is not null");
            return (Criteria) this;
        }

        public Criteria andSubmitbyEqualTo(String value) {
            addCriterion("SUBMITBY =", value, "submitby");
            return (Criteria) this;
        }

        public Criteria andSubmitbyNotEqualTo(String value) {
            addCriterion("SUBMITBY <>", value, "submitby");
            return (Criteria) this;
        }

        public Criteria andSubmitbyGreaterThan(String value) {
            addCriterion("SUBMITBY >", value, "submitby");
            return (Criteria) this;
        }

        public Criteria andSubmitbyGreaterThanOrEqualTo(String value) {
            addCriterion("SUBMITBY >=", value, "submitby");
            return (Criteria) this;
        }

        public Criteria andSubmitbyLessThan(String value) {
            addCriterion("SUBMITBY <", value, "submitby");
            return (Criteria) this;
        }

        public Criteria andSubmitbyLessThanOrEqualTo(String value) {
            addCriterion("SUBMITBY <=", value, "submitby");
            return (Criteria) this;
        }

        public Criteria andSubmitbyLike(String value) {
            addCriterion("SUBMITBY like", value, "submitby");
            return (Criteria) this;
        }

        public Criteria andSubmitbyNotLike(String value) {
            addCriterion("SUBMITBY not like", value, "submitby");
            return (Criteria) this;
        }

        public Criteria andSubmitbyIn(List<String> values) {
            addCriterion("SUBMITBY in", values, "submitby");
            return (Criteria) this;
        }

        public Criteria andSubmitbyNotIn(List<String> values) {
            addCriterion("SUBMITBY not in", values, "submitby");
            return (Criteria) this;
        }

        public Criteria andSubmitbyBetween(String value1, String value2) {
            addCriterion("SUBMITBY between", value1, value2, "submitby");
            return (Criteria) this;
        }

        public Criteria andSubmitbyNotBetween(String value1, String value2) {
            addCriterion("SUBMITBY not between", value1, value2, "submitby");
            return (Criteria) this;
        }

        public Criteria andMemctlnoIsNull() {
            addCriterion("MEMCTLNO is null");
            return (Criteria) this;
        }

        public Criteria andMemctlnoIsNotNull() {
            addCriterion("MEMCTLNO is not null");
            return (Criteria) this;
        }

        public Criteria andMemctlnoEqualTo(String value) {
            addCriterion("MEMCTLNO =", value, "memctlno");
            return (Criteria) this;
        }

        public Criteria andMemctlnoNotEqualTo(String value) {
            addCriterion("MEMCTLNO <>", value, "memctlno");
            return (Criteria) this;
        }

        public Criteria andMemctlnoGreaterThan(String value) {
            addCriterion("MEMCTLNO >", value, "memctlno");
            return (Criteria) this;
        }

        public Criteria andMemctlnoGreaterThanOrEqualTo(String value) {
            addCriterion("MEMCTLNO >=", value, "memctlno");
            return (Criteria) this;
        }

        public Criteria andMemctlnoLessThan(String value) {
            addCriterion("MEMCTLNO <", value, "memctlno");
            return (Criteria) this;
        }

        public Criteria andMemctlnoLessThanOrEqualTo(String value) {
            addCriterion("MEMCTLNO <=", value, "memctlno");
            return (Criteria) this;
        }

        public Criteria andMemctlnoLike(String value) {
            addCriterion("MEMCTLNO like", value, "memctlno");
            return (Criteria) this;
        }

        public Criteria andMemctlnoNotLike(String value) {
            addCriterion("MEMCTLNO not like", value, "memctlno");
            return (Criteria) this;
        }

        public Criteria andMemctlnoIn(List<String> values) {
            addCriterion("MEMCTLNO in", values, "memctlno");
            return (Criteria) this;
        }

        public Criteria andMemctlnoNotIn(List<String> values) {
            addCriterion("MEMCTLNO not in", values, "memctlno");
            return (Criteria) this;
        }

        public Criteria andMemctlnoBetween(String value1, String value2) {
            addCriterion("MEMCTLNO between", value1, value2, "memctlno");
            return (Criteria) this;
        }

        public Criteria andMemctlnoNotBetween(String value1, String value2) {
            addCriterion("MEMCTLNO not between", value1, value2, "memctlno");
            return (Criteria) this;
        }

        public Criteria andLastsnoIsNull() {
            addCriterion("LASTSNO is null");
            return (Criteria) this;
        }

        public Criteria andLastsnoIsNotNull() {
            addCriterion("LASTSNO is not null");
            return (Criteria) this;
        }

        public Criteria andLastsnoEqualTo(Integer value) {
            addCriterion("LASTSNO =", value, "lastsno");
            return (Criteria) this;
        }

        public Criteria andLastsnoNotEqualTo(Integer value) {
            addCriterion("LASTSNO <>", value, "lastsno");
            return (Criteria) this;
        }

        public Criteria andLastsnoGreaterThan(Integer value) {
            addCriterion("LASTSNO >", value, "lastsno");
            return (Criteria) this;
        }

        public Criteria andLastsnoGreaterThanOrEqualTo(Integer value) {
            addCriterion("LASTSNO >=", value, "lastsno");
            return (Criteria) this;
        }

        public Criteria andLastsnoLessThan(Integer value) {
            addCriterion("LASTSNO <", value, "lastsno");
            return (Criteria) this;
        }

        public Criteria andLastsnoLessThanOrEqualTo(Integer value) {
            addCriterion("LASTSNO <=", value, "lastsno");
            return (Criteria) this;
        }

        public Criteria andLastsnoIn(List<Integer> values) {
            addCriterion("LASTSNO in", values, "lastsno");
            return (Criteria) this;
        }

        public Criteria andLastsnoNotIn(List<Integer> values) {
            addCriterion("LASTSNO not in", values, "lastsno");
            return (Criteria) this;
        }

        public Criteria andLastsnoBetween(Integer value1, Integer value2) {
            addCriterion("LASTSNO between", value1, value2, "lastsno");
            return (Criteria) this;
        }

        public Criteria andLastsnoNotBetween(Integer value1, Integer value2) {
            addCriterion("LASTSNO not between", value1, value2, "lastsno");
            return (Criteria) this;
        }

        public Criteria andMarkbyIsNull() {
            addCriterion("MARKBY is null");
            return (Criteria) this;
        }

        public Criteria andMarkbyIsNotNull() {
            addCriterion("MARKBY is not null");
            return (Criteria) this;
        }

        public Criteria andMarkbyEqualTo(String value) {
            addCriterion("MARKBY =", value, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkbyNotEqualTo(String value) {
            addCriterion("MARKBY <>", value, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkbyGreaterThan(String value) {
            addCriterion("MARKBY >", value, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkbyGreaterThanOrEqualTo(String value) {
            addCriterion("MARKBY >=", value, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkbyLessThan(String value) {
            addCriterion("MARKBY <", value, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkbyLessThanOrEqualTo(String value) {
            addCriterion("MARKBY <=", value, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkbyLike(String value) {
            addCriterion("MARKBY like", value, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkbyNotLike(String value) {
            addCriterion("MARKBY not like", value, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkbyIn(List<String> values) {
            addCriterion("MARKBY in", values, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkbyNotIn(List<String> values) {
            addCriterion("MARKBY not in", values, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkbyBetween(String value1, String value2) {
            addCriterion("MARKBY between", value1, value2, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkbyNotBetween(String value1, String value2) {
            addCriterion("MARKBY not between", value1, value2, "markby");
            return (Criteria) this;
        }

        public Criteria andMarkdtIsNull() {
            addCriterion("MARKDT is null");
            return (Criteria) this;
        }

        public Criteria andMarkdtIsNotNull() {
            addCriterion("MARKDT is not null");
            return (Criteria) this;
        }

        public Criteria andMarkdtEqualTo(Date value) {
            addCriterion("MARKDT =", value, "markdt");
            return (Criteria) this;
        }

        public Criteria andMarkdtNotEqualTo(Date value) {
            addCriterion("MARKDT <>", value, "markdt");
            return (Criteria) this;
        }

        public Criteria andMarkdtGreaterThan(Date value) {
            addCriterion("MARKDT >", value, "markdt");
            return (Criteria) this;
        }

        public Criteria andMarkdtGreaterThanOrEqualTo(Date value) {
            addCriterion("MARKDT >=", value, "markdt");
            return (Criteria) this;
        }

        public Criteria andMarkdtLessThan(Date value) {
            addCriterion("MARKDT <", value, "markdt");
            return (Criteria) this;
        }

        public Criteria andMarkdtLessThanOrEqualTo(Date value) {
            addCriterion("MARKDT <=", value, "markdt");
            return (Criteria) this;
        }

        public Criteria andMarkdtIn(List<Date> values) {
            addCriterion("MARKDT in", values, "markdt");
            return (Criteria) this;
        }

        public Criteria andMarkdtNotIn(List<Date> values) {
            addCriterion("MARKDT not in", values, "markdt");
            return (Criteria) this;
        }

        public Criteria andMarkdtBetween(Date value1, Date value2) {
            addCriterion("MARKDT between", value1, value2, "markdt");
            return (Criteria) this;
        }

        public Criteria andMarkdtNotBetween(Date value1, Date value2) {
            addCriterion("MARKDT not between", value1, value2, "markdt");
            return (Criteria) this;
        }

        public Criteria andProviderNameIsNull() {
            addCriterion("PROVIDER_NAME is null");
            return (Criteria) this;
        }

        public Criteria andProviderNameIsNotNull() {
            addCriterion("PROVIDER_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andProviderNameEqualTo(Object value) {
            addCriterion("PROVIDER_NAME =", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameNotEqualTo(Object value) {
            addCriterion("PROVIDER_NAME <>", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameGreaterThan(Object value) {
            addCriterion("PROVIDER_NAME >", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameGreaterThanOrEqualTo(Object value) {
            addCriterion("PROVIDER_NAME >=", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameLessThan(Object value) {
            addCriterion("PROVIDER_NAME <", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameLessThanOrEqualTo(Object value) {
            addCriterion("PROVIDER_NAME <=", value, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameIn(List<Object> values) {
            addCriterion("PROVIDER_NAME in", values, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameNotIn(List<Object> values) {
            addCriterion("PROVIDER_NAME not in", values, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameBetween(Object value1, Object value2) {
            addCriterion("PROVIDER_NAME between", value1, value2, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderNameNotBetween(Object value1, Object value2) {
            addCriterion("PROVIDER_NAME not between", value1, value2, "providerName");
            return (Criteria) this;
        }

        public Criteria andProviderCodeIsNull() {
            addCriterion("PROVIDER_CODE is null");
            return (Criteria) this;
        }

        public Criteria andProviderCodeIsNotNull() {
            addCriterion("PROVIDER_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andProviderCodeEqualTo(String value) {
            addCriterion("PROVIDER_CODE =", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeNotEqualTo(String value) {
            addCriterion("PROVIDER_CODE <>", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeGreaterThan(String value) {
            addCriterion("PROVIDER_CODE >", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_CODE >=", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeLessThan(String value) {
            addCriterion("PROVIDER_CODE <", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_CODE <=", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeLike(String value) {
            addCriterion("PROVIDER_CODE like", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeNotLike(String value) {
            addCriterion("PROVIDER_CODE not like", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeIn(List<String> values) {
            addCriterion("PROVIDER_CODE in", values, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeNotIn(List<String> values) {
            addCriterion("PROVIDER_CODE not in", values, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeBetween(String value1, String value2) {
            addCriterion("PROVIDER_CODE between", value1, value2, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_CODE not between", value1, value2, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIsNull() {
            addCriterion("PROVINCE_CODE is null");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIsNotNull() {
            addCriterion("PROVINCE_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeEqualTo(String value) {
            addCriterion("PROVINCE_CODE =", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotEqualTo(String value) {
            addCriterion("PROVINCE_CODE <>", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeGreaterThan(String value) {
            addCriterion("PROVINCE_CODE >", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PROVINCE_CODE >=", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLessThan(String value) {
            addCriterion("PROVINCE_CODE <", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLessThanOrEqualTo(String value) {
            addCriterion("PROVINCE_CODE <=", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLike(String value) {
            addCriterion("PROVINCE_CODE like", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotLike(String value) {
            addCriterion("PROVINCE_CODE not like", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIn(List<String> values) {
            addCriterion("PROVINCE_CODE in", values, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotIn(List<String> values) {
            addCriterion("PROVINCE_CODE not in", values, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeBetween(String value1, String value2) {
            addCriterion("PROVINCE_CODE between", value1, value2, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotBetween(String value1, String value2) {
            addCriterion("PROVINCE_CODE not between", value1, value2, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeIsNull() {
            addCriterion("CITY_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCityCodeIsNotNull() {
            addCriterion("CITY_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCityCodeEqualTo(String value) {
            addCriterion("CITY_CODE =", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotEqualTo(String value) {
            addCriterion("CITY_CODE <>", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeGreaterThan(String value) {
            addCriterion("CITY_CODE >", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CITY_CODE >=", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLessThan(String value) {
            addCriterion("CITY_CODE <", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLessThanOrEqualTo(String value) {
            addCriterion("CITY_CODE <=", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLike(String value) {
            addCriterion("CITY_CODE like", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotLike(String value) {
            addCriterion("CITY_CODE not like", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeIn(List<String> values) {
            addCriterion("CITY_CODE in", values, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotIn(List<String> values) {
            addCriterion("CITY_CODE not in", values, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeBetween(String value1, String value2) {
            addCriterion("CITY_CODE between", value1, value2, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotBetween(String value1, String value2) {
            addCriterion("CITY_CODE not between", value1, value2, "cityCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeIsNull() {
            addCriterion("DISTRICT_CODE is null");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeIsNotNull() {
            addCriterion("DISTRICT_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeEqualTo(String value) {
            addCriterion("DISTRICT_CODE =", value, "districtCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeNotEqualTo(String value) {
            addCriterion("DISTRICT_CODE <>", value, "districtCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeGreaterThan(String value) {
            addCriterion("DISTRICT_CODE >", value, "districtCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeGreaterThanOrEqualTo(String value) {
            addCriterion("DISTRICT_CODE >=", value, "districtCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeLessThan(String value) {
            addCriterion("DISTRICT_CODE <", value, "districtCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeLessThanOrEqualTo(String value) {
            addCriterion("DISTRICT_CODE <=", value, "districtCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeLike(String value) {
            addCriterion("DISTRICT_CODE like", value, "districtCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeNotLike(String value) {
            addCriterion("DISTRICT_CODE not like", value, "districtCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeIn(List<String> values) {
            addCriterion("DISTRICT_CODE in", values, "districtCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeNotIn(List<String> values) {
            addCriterion("DISTRICT_CODE not in", values, "districtCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeBetween(String value1, String value2) {
            addCriterion("DISTRICT_CODE between", value1, value2, "districtCode");
            return (Criteria) this;
        }

        public Criteria andDistrictCodeNotBetween(String value1, String value2) {
            addCriterion("DISTRICT_CODE not between", value1, value2, "districtCode");
            return (Criteria) this;
        }

        public Criteria andBankaccnoIsNull() {
            addCriterion("BANKACCNO is null");
            return (Criteria) this;
        }

        public Criteria andBankaccnoIsNotNull() {
            addCriterion("BANKACCNO is not null");
            return (Criteria) this;
        }

        public Criteria andBankaccnoEqualTo(String value) {
            addCriterion("BANKACCNO =", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotEqualTo(String value) {
            addCriterion("BANKACCNO <>", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoGreaterThan(String value) {
            addCriterion("BANKACCNO >", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoGreaterThanOrEqualTo(String value) {
            addCriterion("BANKACCNO >=", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoLessThan(String value) {
            addCriterion("BANKACCNO <", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoLessThanOrEqualTo(String value) {
            addCriterion("BANKACCNO <=", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoLike(String value) {
            addCriterion("BANKACCNO like", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotLike(String value) {
            addCriterion("BANKACCNO not like", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoIn(List<String> values) {
            addCriterion("BANKACCNO in", values, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotIn(List<String> values) {
            addCriterion("BANKACCNO not in", values, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoBetween(String value1, String value2) {
            addCriterion("BANKACCNO between", value1, value2, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotBetween(String value1, String value2) {
            addCriterion("BANKACCNO not between", value1, value2, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBanknmIsNull() {
            addCriterion("BANKNM is null");
            return (Criteria) this;
        }

        public Criteria andBanknmIsNotNull() {
            addCriterion("BANKNM is not null");
            return (Criteria) this;
        }

        public Criteria andBanknmEqualTo(Object value) {
            addCriterion("BANKNM =", value, "banknm");
            return (Criteria) this;
        }

        public Criteria andBanknmNotEqualTo(Object value) {
            addCriterion("BANKNM <>", value, "banknm");
            return (Criteria) this;
        }

        public Criteria andBanknmGreaterThan(Object value) {
            addCriterion("BANKNM >", value, "banknm");
            return (Criteria) this;
        }

        public Criteria andBanknmGreaterThanOrEqualTo(Object value) {
            addCriterion("BANKNM >=", value, "banknm");
            return (Criteria) this;
        }

        public Criteria andBanknmLessThan(Object value) {
            addCriterion("BANKNM <", value, "banknm");
            return (Criteria) this;
        }

        public Criteria andBanknmLessThanOrEqualTo(Object value) {
            addCriterion("BANKNM <=", value, "banknm");
            return (Criteria) this;
        }

        public Criteria andBanknmIn(List<Object> values) {
            addCriterion("BANKNM in", values, "banknm");
            return (Criteria) this;
        }

        public Criteria andBanknmNotIn(List<Object> values) {
            addCriterion("BANKNM not in", values, "banknm");
            return (Criteria) this;
        }

        public Criteria andBanknmBetween(Object value1, Object value2) {
            addCriterion("BANKNM between", value1, value2, "banknm");
            return (Criteria) this;
        }

        public Criteria andBanknmNotBetween(Object value1, Object value2) {
            addCriterion("BANKNM not between", value1, value2, "banknm");
            return (Criteria) this;
        }

        public Criteria andBankaccnmIsNull() {
            addCriterion("BANKACCNM is null");
            return (Criteria) this;
        }

        public Criteria andBankaccnmIsNotNull() {
            addCriterion("BANKACCNM is not null");
            return (Criteria) this;
        }

        public Criteria andBankaccnmEqualTo(Object value) {
            addCriterion("BANKACCNM =", value, "bankaccnm");
            return (Criteria) this;
        }

        public Criteria andBankaccnmNotEqualTo(Object value) {
            addCriterion("BANKACCNM <>", value, "bankaccnm");
            return (Criteria) this;
        }

        public Criteria andBankaccnmGreaterThan(Object value) {
            addCriterion("BANKACCNM >", value, "bankaccnm");
            return (Criteria) this;
        }

        public Criteria andBankaccnmGreaterThanOrEqualTo(Object value) {
            addCriterion("BANKACCNM >=", value, "bankaccnm");
            return (Criteria) this;
        }

        public Criteria andBankaccnmLessThan(Object value) {
            addCriterion("BANKACCNM <", value, "bankaccnm");
            return (Criteria) this;
        }

        public Criteria andBankaccnmLessThanOrEqualTo(Object value) {
            addCriterion("BANKACCNM <=", value, "bankaccnm");
            return (Criteria) this;
        }

        public Criteria andBankaccnmIn(List<Object> values) {
            addCriterion("BANKACCNM in", values, "bankaccnm");
            return (Criteria) this;
        }

        public Criteria andBankaccnmNotIn(List<Object> values) {
            addCriterion("BANKACCNM not in", values, "bankaccnm");
            return (Criteria) this;
        }

        public Criteria andBankaccnmBetween(Object value1, Object value2) {
            addCriterion("BANKACCNM between", value1, value2, "bankaccnm");
            return (Criteria) this;
        }

        public Criteria andBankaccnmNotBetween(Object value1, Object value2) {
            addCriterion("BANKACCNM not between", value1, value2, "bankaccnm");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoIsNull() {
            addCriterion("REFERREDOPFORMNO is null");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoIsNotNull() {
            addCriterion("REFERREDOPFORMNO is not null");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoEqualTo(String value) {
            addCriterion("REFERREDOPFORMNO =", value, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoNotEqualTo(String value) {
            addCriterion("REFERREDOPFORMNO <>", value, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoGreaterThan(String value) {
            addCriterion("REFERREDOPFORMNO >", value, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoGreaterThanOrEqualTo(String value) {
            addCriterion("REFERREDOPFORMNO >=", value, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoLessThan(String value) {
            addCriterion("REFERREDOPFORMNO <", value, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoLessThanOrEqualTo(String value) {
            addCriterion("REFERREDOPFORMNO <=", value, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoLike(String value) {
            addCriterion("REFERREDOPFORMNO like", value, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoNotLike(String value) {
            addCriterion("REFERREDOPFORMNO not like", value, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoIn(List<String> values) {
            addCriterion("REFERREDOPFORMNO in", values, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoNotIn(List<String> values) {
            addCriterion("REFERREDOPFORMNO not in", values, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoBetween(String value1, String value2) {
            addCriterion("REFERREDOPFORMNO between", value1, value2, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andReferredopformnoNotBetween(String value1, String value2) {
            addCriterion("REFERREDOPFORMNO not between", value1, value2, "referredopformno");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxIsNull() {
            addCriterion("ICLAIMSTSWX is null");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxIsNotNull() {
            addCriterion("ICLAIMSTSWX is not null");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxEqualTo(String value) {
            addCriterion("ICLAIMSTSWX =", value, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxNotEqualTo(String value) {
            addCriterion("ICLAIMSTSWX <>", value, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxGreaterThan(String value) {
            addCriterion("ICLAIMSTSWX >", value, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxGreaterThanOrEqualTo(String value) {
            addCriterion("ICLAIMSTSWX >=", value, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxLessThan(String value) {
            addCriterion("ICLAIMSTSWX <", value, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxLessThanOrEqualTo(String value) {
            addCriterion("ICLAIMSTSWX <=", value, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxLike(String value) {
            addCriterion("ICLAIMSTSWX like", value, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxNotLike(String value) {
            addCriterion("ICLAIMSTSWX not like", value, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxIn(List<String> values) {
            addCriterion("ICLAIMSTSWX in", values, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxNotIn(List<String> values) {
            addCriterion("ICLAIMSTSWX not in", values, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxBetween(String value1, String value2) {
            addCriterion("ICLAIMSTSWX between", value1, value2, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andIclaimstswxNotBetween(String value1, String value2) {
            addCriterion("ICLAIMSTSWX not between", value1, value2, "iclaimstswx");
            return (Criteria) this;
        }

        public Criteria andRegtypeIsNull() {
            addCriterion("REGTYPE is null");
            return (Criteria) this;
        }

        public Criteria andRegtypeIsNotNull() {
            addCriterion("REGTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andRegtypeEqualTo(String value) {
            addCriterion("REGTYPE =", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeNotEqualTo(String value) {
            addCriterion("REGTYPE <>", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeGreaterThan(String value) {
            addCriterion("REGTYPE >", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeGreaterThanOrEqualTo(String value) {
            addCriterion("REGTYPE >=", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeLessThan(String value) {
            addCriterion("REGTYPE <", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeLessThanOrEqualTo(String value) {
            addCriterion("REGTYPE <=", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeLike(String value) {
            addCriterion("REGTYPE like", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeNotLike(String value) {
            addCriterion("REGTYPE not like", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeIn(List<String> values) {
            addCriterion("REGTYPE in", values, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeNotIn(List<String> values) {
            addCriterion("REGTYPE not in", values, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeBetween(String value1, String value2) {
            addCriterion("REGTYPE between", value1, value2, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeNotBetween(String value1, String value2) {
            addCriterion("REGTYPE not between", value1, value2, "regtype");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtIsNull() {
            addCriterion("ADMISSIONDT is null");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtIsNotNull() {
            addCriterion("ADMISSIONDT is not null");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtEqualTo(Date value) {
            addCriterion("ADMISSIONDT =", value, "admissiondt");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtNotEqualTo(Date value) {
            addCriterion("ADMISSIONDT <>", value, "admissiondt");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtGreaterThan(Date value) {
            addCriterion("ADMISSIONDT >", value, "admissiondt");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtGreaterThanOrEqualTo(Date value) {
            addCriterion("ADMISSIONDT >=", value, "admissiondt");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtLessThan(Date value) {
            addCriterion("ADMISSIONDT <", value, "admissiondt");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtLessThanOrEqualTo(Date value) {
            addCriterion("ADMISSIONDT <=", value, "admissiondt");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtIn(List<Date> values) {
            addCriterion("ADMISSIONDT in", values, "admissiondt");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtNotIn(List<Date> values) {
            addCriterion("ADMISSIONDT not in", values, "admissiondt");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtBetween(Date value1, Date value2) {
            addCriterion("ADMISSIONDT between", value1, value2, "admissiondt");
            return (Criteria) this;
        }

        public Criteria andAdmissiondtNotBetween(Date value1, Date value2) {
            addCriterion("ADMISSIONDT not between", value1, value2, "admissiondt");
            return (Criteria) this;
        }

        public Criteria andDwldtIsNull() {
            addCriterion("DWLDT is null");
            return (Criteria) this;
        }

        public Criteria andDwldtIsNotNull() {
            addCriterion("DWLDT is not null");
            return (Criteria) this;
        }

        public Criteria andDwldtEqualTo(Date value) {
            addCriterion("DWLDT =", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtNotEqualTo(Date value) {
            addCriterion("DWLDT <>", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtGreaterThan(Date value) {
            addCriterion("DWLDT >", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtGreaterThanOrEqualTo(Date value) {
            addCriterion("DWLDT >=", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtLessThan(Date value) {
            addCriterion("DWLDT <", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtLessThanOrEqualTo(Date value) {
            addCriterion("DWLDT <=", value, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtIn(List<Date> values) {
            addCriterion("DWLDT in", values, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtNotIn(List<Date> values) {
            addCriterion("DWLDT not in", values, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtBetween(Date value1, Date value2) {
            addCriterion("DWLDT between", value1, value2, "dwldt");
            return (Criteria) this;
        }

        public Criteria andDwldtNotBetween(Date value1, Date value2) {
            addCriterion("DWLDT not between", value1, value2, "dwldt");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}